Query Menu

With the Query Menu iPart, you can display a query, set with whatever title, parameters, columns, labels, and sorting you need, and you can enable exports, which adds icons for sending the data to Word, Excel, PDF, and CSV. You can also organize helpful queries into a folder and point the iPart to that folder. When the page loads, the iPart displays the first query at the top of that folder, and it presents a drop-down menu of additional queries available, organizing them by subfolders, if any. When the user clicks on a query from the menu, the iPart immediately runs that query and displays the results.

• Name - Enter a name for the content item. This text appears during design mode (configuration).
• Title - Enter the text to display above this iPart on the rendered page. If blank, no title displays.
• Do not render in design mode - Select this option to prevent content record data from being loaded in the content editor. This improves performance during design time (configuration).
• Display a border around this content - Select this option to display a border around this iPart on the rendered page.
• Display for authorized users only - Hides the iPart from public users when accessing data for another person, which prevents spoofing (changing the ID in the URL to access another's data). Disable this option if you need to make this iPart visible to public users, such as for a public profile.
• Display for authorized users only - Hides the iPart from public users when accessing data for another person, which prevents spoofing (changing the ID in the URL to access another's data). Disable this option if you need to make this iPart visible to public users, such as for a public profile. Note: This iPart may behave differently if you have edited the permissions defined in your ClaimsMap.xml and ClaimTemplates.xml files. By default, only System Administrators and members of the Staff Group have the claims to access data for any user in the system.
• Open link in a pop-up - Select this option to display the target page in a pop-up. Default is navigate to the target page.
• Enable export of query results - Select this option to display icons to export the data to .doc (Word document), .xls (Excel spreadsheet), .pdf (Adobe PDF), or .csv (comma-delimited file). The icons display above the query results.
• Map query results if address is available - Enable this option if you want to automatically map your query results. Only one address property per query can be mapped. When this option is enabled, the iPart looks for the following address properties in this order and maps the first one it finds: FullAddress, Address, FullAddressText, AddressText, Address Text, and Full Address Text.
• Source query or folder - Select the the path in the Document System to display for the source of the data.
• Menu label - Enter a label to display next to the drop-down list of available queries for user selection (when multiple queries are available).
• Results to display per page - Enter the number of results to display per page. 0 = display all results. The default value is 20 listings before paging is activated.
• Results display style - Select the query results style to display in the rendered page:
  • Simple style displays the results in a list with the number of results per page as specified by Results to display per page.
  • Advanced style displays arrows and page selection links for user navigation and allows the user to specify the results to display per page.
  • NextPrev style displays simple next and previous buttons to page through results.
  • Slider style displays a slider below the grid which can be used to navigate through results.